<%-- 
    Document   : expert
    Created on : Jan 26, 2013, 11:12:39 PM
    Author     : jaguar
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="connection.jsp"%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Experts page for User </title>
<link rel="stylesheet" type="text/css" href="css/theme.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" />
<script>
   var StyleFile = "theme" + document.cookie.charAt(6) + ".css";
   document.writeln('<link rel="stylesheet" type="text/css" href="css/' + StyleFile + '">');
</script>
<link rel="stylesheet" href="js/jquery-ui-1.8.23.custom/development-bundle/themes/base/jquery.ui.all.css">
        <script src="js/jquery-ui-1.8.23.custom/js/jquery-1.7.2.min.js" type="text/javascript"></script> 
        <script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.accordion.js"></script>
        
         
        <script>
    $(function() {
		$( "#sidebar" ).accordion({
			autoHeight:false,
                        event: "mouseover"
		});
	});
    
</script>
<!--[if IE]>
<link rel="stylesheet" type="text/css" href="css/ie-sucks.css" />
<![endif]-->
</head>

<body>
	<div id="container">
    	<div id="header">
        	<h2>Stock Market Website</h2>
    <div id="topmenu">
            	<ul>
                        <li><a href="user_home.jsp">Dashboard</a></li>
                        <li><a href="portfolio.jsp">Portfolio</a></li>
                        <li><a href="charts.jsp">Charts</a></li>
                        <!--<li><a href="chatgroup_user.jsp">Chat Group</a></li>-->
                        <li class="current"><a href="experts_user.jsp">Experts</a></li>
                        <!--                    <li><a href="emails.jsp">Emails</a></li>-->
                    </ul>
          </div>
      </div>
 <div id="top-panel">
          <div id="panel">
          <form action="" name="quoteform" >
              	<input type="text" placeholder="Enter company symbol" name="sym_nm" id="sym_id" />
                <input type="submit" value="Get Stock Value" />
            </form>
          </div>
      </div>       
        <div id="wrapper">
            <div id="content">
                <div id="box">
                <h3>Experts</h3>
                <p>
                    <%
                        String msg=null;
                        if(request.getParameter("msg")!=null)
                        {
                            msg=request.getParameter("msg");
                            out.print("<font></font>");
                            out.println(msg);
                        }
                        st = con.createStatement();
                        rs = st.executeQuery("select ex_fname,ex_lname,review.review from expert,package,review where expert.pac_id=package.pac_id and expert.ex_id=review.ex_id");                        
                     %>
                     <table border='1'>
                         <thead>
                             <tr>
                            <th><center><b>Name</b></center></th>
                            <th><center><b>Review</b></center></th>
                            </tr>
                    </thead>
                        <%   
                        
                        while(rs.next())
                        {
                            out.print("<tr>");
                                                                           
                            out.print("<td>");
                            out.print(rs.getString(1)+" "+rs.getString(2));
                            out.print("</td>");
                            
                            out.print("<td>");
                            out.print(rs.getString(3));
                            out.print("</td>");

                        }
                        rs.close();
                        %>
                     
                     </table>
                </div>
            </div>
            </div>
            <%@include file="admin_right_nav.jsp" %>